﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace UserSQLGenerator
{
    class SQLWriter
    {
        public SQLWriter()
        {
            //initialize
        }

        public void StudentSQL(List<string>[] list)
        {
            string query;
            for (int i = 0; i < list[0].Count(); i++)
            {
                query = "INSERT INTO Student VALUES("
                    + "'" + list[0][i] + "', "
                    + "'" + list[1][i] + "', "
                    + "'" + list[2][i] + "', "
                    + "'" + list[3][i] + "', "
                    + "'" + list[4][i] + "', "
                    + "'" + list[5][i] + "', "
                    + "'" + list[6][i] + "', "
                    + "'" + list[7][i] + "')";
            }
        }
        public void TransferStudentsSQL(List<string>[] list)
        {
            string query;
            for (int i = 0; i < list[0].Count(); i++)
            {
                query = "INSERT INTO TransferStudents VALUES('" + list[0][i] + "')";
            }
        }
        public void InternationalStudentsSQL(List<string>[] list)
        {
            string query;
            for (int i = 0; i < list[0].Count(); i++)
            {
                query = "INSERT INTO InternationalStudents VALUES('" + list[0][i] + "')";
            }
        }
        public void HonorStudentsSQL(List<string>[] list)
        {
            string query;
            for (int i = 0; i < list[0].Count(); i++)
            {
                query = "INSERT INTO HonorStudents VALUES('" + list[0][i] + "')";
            }
        }
    };
}
